Location: Remote

Duration: Long term

Key Objectives:

• Hands-on experience with:

• EDW source to target testing (SQL scripting - manual and automation).

• Data transformation/manipulation testing (SQL scripting - manual and automation).

• Data quality/completeness validation (SQL scripting - manual and automation).

• Experience in running the processes through the scheduler.

• Quality Assurance, Process Improvement and Collaboration:

• Develop and execute (Develop) comprehensive test plans to validate data within on-prem and cloud data warehouses.

• Conduct thorough testing of ETL processes, dimensional data models, and reporting outputs.

• Identify, document, and track data quality issues, working closely with data engineers to resolve them.

• Validate data loading, transformation, and aggregation processes.

• Ensure data consistency and integrity across different data sources and systems.

• Collaborate with the Data Quality and Data Engineering team to define quality benchmarks and metrics.

• Continuously improve QA testing strategies and methodologies.

• Implement best practices for data validation and error handling.

• Assist in the design and implementation of data quality assurance tools and frameworks.

• Work closely with BA, data architect, data engineers, QA and stakeholders to understand data requirements and deliverables.

• Work closely with the Lead Data QA Engineer to design, develop, maintain and support testing infrastructure.

• Provide detailed reports on data quality findings and testing outcomes.

• Extensively used Task management and defect management tool (i.e. Jira and Confluence) to manage deliverable.

• Well versed with the comprehensive QA testing methodology (i.e. functional, non-functional, system, regression, smoke test, performance testing, black box testing, etc.).

• Contribute insights and recommendations to enhance data quality and processing efficiency.

Requirements

• Bachelors or Masters in Computer Science or equivalent.

• Experience with Insurance (industry domain) Data Warehouse, data and it's processes

• Strong understanding of Data Warehouse & Data Quality fundamentals.

• 3 to 5 years of experience in data warehouse development/testing.

• 3 to 5 years of experience with SQL Server and SSIS/SSAS/SSRS testing.

• Must be experienced in Data Warehousing Projects with good knowledge of ETL testing.

• Strong in SQL, RDBMS, ETL, and DW concepts.

• Experience in validating Reports/Dashboards on tools like Tableau, MS Power BI, etc.

• Great attention to detail with a result-driven test approach.

• Self-starter; strong drive, bias-to-action, commitment with solid work ethics.

• Willingness to take on big challenges and own the results from brainstorming to execution.

• Excellent written and verbal communication skills - Able to influence others effectively.

• Willingness to provide occasional off-hour support.

You're a Great Fit If You Have:

• Minimum 3 to 5 years of Quality Assurance experience (manual/automated testing) with a proven track record of improving Data Quality by

• implementing QA best practices within organization.

• SSIS & MSSQL experience (intermediate or senior level).

• Experience with Insurance Data Warehouse, data and it's processes

• Experience with the Snowflake and DBT is a plus.

• Experience in using QA automation tools.

• ETL process knowledge; Knowledge of data warehouse testing procedures.

Desirable qualifications/pluses:

• Knowledge of Insurance Data & its processes.

• Data validation experience between on-prem & cloud (i.e. hybrid) architecture.

• Familiarity with cloud computing and the data ecosystem on Snowflake.

Why work with us:

• Relationship ensures quickest traction and decision

• We have been serving the industry for over 2 decades!